package com.jwm.power.model.excel;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;

import java.util.Date;


@HeadRowHeight(value = 30)
@ContentRowHeight(value = 20)
public class ExcelCusarchive {

    @ExcelProperty(value = "客户编码", index = 0)
    @ColumnWidth(value = 20)
    private String CusCode;
    @ExcelProperty(value = "客户简称", index = 1)
    @ColumnWidth(value = 20)
    private String CusName;
    @ExcelProperty(value = "客户分类编码", index = 2)
    @ColumnWidth(value = 20)
    private String CusClassCode;
    @ExcelProperty(value = "客户自定义项1", index = 3)
    @ColumnWidth(value = 20)
    private String CusClass;
    @ExcelProperty(value = "客户自定义项3", index = 4)
    @ColumnWidth(value = 20)
    private String CusDis;
    @ExcelProperty(value = "客户自定义项3", index = 5)
    @ColumnWidth(value = 20)
    private String Province;
    @ExcelProperty(value = "客户自定义项4", index = 6)
    @ColumnWidth(value = 20)
    private String City;
    @ExcelProperty(value = "客户名称", index = 7)
    @ColumnWidth(value = 20)
    private String NullCell;
    @ExcelProperty(value = "地址", index = 8)
    @ColumnWidth(value = 20)
    private String Address;
    @ExcelProperty(value = "客户自定义项5", index = 9)
    @ColumnWidth(value = 20)
    private String CusType;
    @ExcelProperty(value = "联系人编码", index = 10)
    @ColumnWidth(value = 20)
    private String Contacts;
    @ExcelProperty(value = "客户自定义项6", index = 11)
    @ColumnWidth(value = 20)
    private String NullCell1;
    @ExcelProperty(value = "客户自定义项7", index = 12)
    @ColumnWidth(value = 20)
    private String CusSource;
    @ExcelProperty(value = "手机", index = 13)
    @ColumnWidth(value = 20)
    private String Mobile;
    @ExcelProperty(value = "电话", index = 14)
    @ColumnWidth(value = 20)
    private String Phone;
    @ExcelProperty(value = "传真", index = 15)
    @ColumnWidth(value = 20)
    private String NullCell15;
    @ExcelProperty(value = "客户自定义项8", index = 16)
    @ColumnWidth(value = 20)
    private String NullCell16;
    @ExcelProperty(value = "Email地址", index = 17)
    @ColumnWidth(value = 20)
    private String Email;
    @ExcelProperty(value = "客户自定义项9", index = 18)
    @ColumnWidth(value = 20)
    private String NullCell18;
    @ExcelProperty(value = "客户自定义项10", index = 19)
    @ColumnWidth(value = 20)
    private String FirstOrder;

    @ExcelProperty(value = "专管业务员编码", index = 20)
    @ColumnWidth(value = 20)
    private String T6UserCode;
    @ExcelProperty(value = "分管部门编码", index = 21)
    @ColumnWidth(value = 20)
    private String T_DeptCode;
    @ExcelProperty(value = "备注", index = 22)
    @ColumnWidth(value = 20)
    private String Remarks;
    @ExcelProperty(value = "客户总公司编码", index = 23)
    @ColumnWidth(value = 20)
    private String NullCell23;
    @ExcelProperty(value = "地区编码", index = 24)
    @ColumnWidth(value = 20)
    private String NullCell24;
    @ExcelProperty(value = "行业编码", index = 25)
    @ColumnWidth(value = 20)
    private String NullCell25;
    @ExcelProperty(value = "纳税人登记号", index = 26)
    @ColumnWidth(value = 20)
    private String NullCell26;
    @ExcelProperty(value = "开户银行", index = 27)
    @ColumnWidth(value = 20)
    private String NullCell27;
    @ExcelProperty(value = "银行账号", index = 28)
    @ColumnWidth(value = 20)
    private String NullCell28;
    @ExcelProperty(value = "法人", index = 29)
    @ColumnWidth(value = 20)
    private String NullCell29;

    @ExcelProperty(value = "开票单位", index = 30)
    @ColumnWidth(value = 20)
    private String NullCell30;
    @ExcelProperty(value = "邮政编码", index = 31)
    @ColumnWidth(value = 20)
    private String NullCell31;
    @ExcelProperty(value = "发运方式编码", index = 32)
    @ColumnWidth(value = 20)
    private String NullCell32;
    @ExcelProperty(value = "发货仓库编码", index = 33)
    @ColumnWidth(value = 20)
    private String NullCell33;
    @ExcelProperty(value = "应收余额", index = 34)
    @ColumnWidth(value = 20)
    private String NullCell34;
    @ExcelProperty(value = "扣率", index = 35)
    @ColumnWidth(value = 20)
    private String NullCell35;
    @ExcelProperty(value = "信用等级", index = 36)
    @ColumnWidth(value = 20)
    private String NullCell36;
    @ExcelProperty(value = "信用额度", index = 37)
    @ColumnWidth(value = 20)
    private String NullCell7;
    @ExcelProperty(value = "信用期限", index = 38)
    @ColumnWidth(value = 20)
    private String NullCell38;
    @ExcelProperty(value = "付款条件编码", index = 39)
    @ColumnWidth(value = 20)
    private String NullCell39;

    @ExcelProperty(value = "价格级别", index = 40)
    @ColumnWidth(value = 20)
    private String NullCell40;
    @ExcelProperty(value = "是否按总公司控制信用额度", index = 41)
    @ColumnWidth(value = 20)
    private String NullCell41;
    @ExcelProperty(value = "是否控制信用额度", index = 42)
    @ColumnWidth(value = 20)
    private String NullCell42;
    @ExcelProperty(value = "是否控制信用期限", index = 43)
    @ColumnWidth(value = 20)
    private String NullCell43;
    @ExcelProperty(value = "最后交易日期", index = 44)
    @ColumnWidth(value = 20)
    private String NullCell44;
    @ExcelProperty(value = "最后交易金额", index = 45)
    @ColumnWidth(value = 20)
    private String NullCell45;
    @ExcelProperty(value = "最后收款日期", index = 46)
    @ColumnWidth(value = 20)
    private String NullCell46;
    @ExcelProperty(value = "最后收款金额", index = 47)
    @ColumnWidth(value = 20)
    private String NullCell47;
    @ExcelProperty(value = "停用日期", index = 48)
    @ColumnWidth(value = 20)
    private String NullCell48;
    @ExcelProperty(value = "使用频度", index = 49)
    @ColumnWidth(value = 20)
    private String NullCell49;

    @ExcelProperty(value = "建档人", index = 50)
    @ColumnWidth(value = 20)
    private String NullCell50;
    @ExcelProperty(value = "变更人", index = 51)
    @ColumnWidth(value = 20)
    private String NullCell51;
    @ExcelProperty(value = "变更日期", index = 52)
    @ColumnWidth(value = 20)
    private String UpdateDate;
    @ExcelProperty(value = "营业执照是否期限管理", index = 53)
    @ColumnWidth(value = 20)
    private String NullCell53;
    @ExcelProperty(value = "营业执照生效日期", index = 54)
    @ColumnWidth(value = 20)
    private String NullCell54;
    @ExcelProperty(value = "营业执照到期日期", index = 55)
    @ColumnWidth(value = 20)
    private String NullCell55;
    @ExcelProperty(value = "营业执照预警天数", index = 56)
    @ColumnWidth(value = 20)
    private String NullCell56;
    @ExcelProperty(value = "经营许可证是否期限管理", index = 57)
    @ColumnWidth(value = 20)
    private String NullCell57;
    @ExcelProperty(value = "经营许可证生效日期", index = 58)
    @ColumnWidth(value = 20)
    private String NullCell58;
    @ExcelProperty(value = "经营许可证到期日期", index = 59)
    @ColumnWidth(value = 20)
    private String NullCell59;

    @ExcelProperty(value = "经营许可证预警天数", index = 60)
    @ColumnWidth(value = 20)
    private String NullCell60;
    @ExcelProperty(value = "法人委托书是否期限管理", index = 61)
    @ColumnWidth(value = 20)
    private String NullCell61;
    @ExcelProperty(value = "法人委托书生效日期", index = 62)
    @ColumnWidth(value = 20)
    private String NullCell62;
    @ExcelProperty(value = "法人委托书到期日期", index = 63)
    @ColumnWidth(value = 20)
    private String NullCell63;
    @ExcelProperty(value = "法人委托书预警天数", index = 64)
    @ColumnWidth(value = 20)
    private String NullCell64;
    @ExcelProperty(value = "客户自定义项11", index = 65)
    @ColumnWidth(value = 20)
    private String NullCell65;
    @ExcelProperty(value = "客户自定义项12", index = 66)
    @ColumnWidth(value = 20)
    private String NullCell66;
    @ExcelProperty(value = "客户自定义项13", index = 67)
    @ColumnWidth(value = 20)
    private String NullCell67;
    @ExcelProperty(value = "客户自定义项14", index = 68)
    @ColumnWidth(value = 20)
    private String NullCell68;
    @ExcelProperty(value = "客户自定义项15", index = 69)
    @ColumnWidth(value = 20)
    private String NullCell69;

    @ExcelProperty(value = "客户自定义项16", index = 70)
    @ColumnWidth(value = 20)
    private String NullCell70;
    @ExcelProperty(value = "录入日期", index = 71)
    @ColumnWidth(value = 20)
    private String CreateDate;
    @ExcelProperty(value = "录入员", index = 72)
    @ColumnWidth(value = 20)
    private String CreateUser;
}
